In [9]:
Out[9]:
name mfr type calories protein fat sodium fiber carbo sugars potass vitamins shelf weight cups rating
0 100% Bran N C 70 4 1 130 10.0 5.0 6 280 25 3 1.00 0.33 68.402973
1 100% Natural Bran Q C 120 3 5 15 2.0 8.0 8 135 0 3 1.00 1.00 33.983679
2 All-Bran K C 70 4 1 260 9.0 7.0 5 320 25 3 1.00 0.33 59.425505
3 All-Bran with Extra Fiber K C 50 4 0 140 14.0 8.0 0 330 25 3 1.00 0.50 93.704912
4 Almond Delight R C 110 2 2 200 1.0 14.0 8 0 25 3 1.00 0.75 34.384843
5 Apple Cinnamon Cheerios G C 110 2 2 180 1.5 10.5 10 70 25 1 1.00 0.75 29.509541
6 Apple Jacks K C 110 2 0 125 1.0 11.0 14 30 25 2 1.00 1.00 33.174094
7 Basic 4 G C 130 3 2 210 2.0 18.0 8 100 25 3 1.33 0.75 37.038562
8 Bran Chex R C 90 2 1 200 4.0 15.0 6 125 25 1 1.00 0.67 49.120253
9 Bran Flakes P C 90 3 0 210 5.0 13.0 5 190 25 3 1.00 0.67 53.313813
10 Cap'n'Crunch Q C 120 1 2 220 0.0 12.0 12 35 25 2 1.00 0.75 18.042851
11 Cheerios G C 110 6 2 290 2.0 17.0 1 105 25 1 1.00 1.25 50.764999
12 Cinnamon Toast Crunch G C 120 1 3 210 0.0 13.0 9 45 25 2 1.00 0.75 19.823573
13 Clusters G C 110 3 2 140 2.0 13.0 7 105 25 3 1.00 0.50 40.400208
14 Cocoa Puffs G C 110 1 1 180 0.0 12.0 13 55 25 2 1.00 1.00 22.736446
15 Corn Chex R C 110 2 0 280 0.0 22.0 3 25 25 1 1.00 1.00 41.445019
16 Corn Flakes K C 100 2 0 290 1.0 21.0 2 35 25 1 1.00 1.00 45.863324
17 Corn Pops K C 110 1 0 90 1.0 13.0 12 20 25 2 1.00 1.00 35.782791
18 Count Chocula G C 110 1 1 180 0.0 12.0 13 65 25 2 1.00 1.00 22.396513
19 Cracklin' Oat Bran K C 110 3 3 140 4.0 10.0 7 160 25 3 1.00 0.50 40.448772
20 Cream of Wheat (Quick) N H 100 3 0 80 1.0 21.0 0 0 0 2 1.00 1.00 64.533816
21 Crispix K C 110 2 0 220 1.0 21.0 3 30 25 3 1.00 1.00 46.895644
22 Crispy Wheat & Raisins G C 100 2 1 140 2.0 11.0 10 120 25 3 1.00 0.75 36.176196
23 Double Chex R C 100 2 0 190 1.0 18.0 5 80 25 3 1.00 0.75 44.330856
24 Froot Loops K C 110 2 1 125 1.0 11.0 13 30 25 2 1.00 1.00 32.207582
25 Frosted Flakes K C 110 1 0 200 1.0 14.0 11 25 25 1 1.00 0.75 31.435973
26 Frosted Mini-Wheats K C 100 3 0 0 3.0 14.0 7 100 25 2 1.00 0.80 58.345141
27 Fruit & Fibre Dates; Walnuts; and Oats P C 120 3 2 160 5.0 12.0 10 200 25 3 1.25 0.67 40.917047
28 Fruitful Bran K C 120 3 0 240 5.0 14.0 12 190 25 3 1.33 0.67 41.015492
29 Fruity Pebbles P C 110 1 1 135 0.0 13.0 12 25 25 2 1.00 0.75 28.025765
30 Golden Crisp P C 100 2 0 45 0.0 11.0 15 40 25 1 1.00 0.88 35.252444
31 Golden Grahams G C 110 1 1 280 0.0 15.0 9 45 25 2 1.00 0.75 23.804043
32 Grape Nuts Flakes P C 100 3 1 140 3.0 15.0 5 85 25 3 1.00 0.88 52.076897
33 Grape-Nuts P C 110 3 0 170 3.0 17.0 3 90 25 3 1.00 0.25 53.371007
34 Great Grains Pecan P C 120 3 3 75 3.0 13.0 4 100 25 3 1.00 0.33 45.811716
35 Honey Graham Ohs Q C 120 1 2 220 1.0 12.0 11 45 25 2 1.00 1.00 21.871292
36 Honey Nut Cheerios G C 110 3 1 250 1.5 11.5 10 90 25 1 1.00 0.75 31.072217
37 Honey-comb P C 110 1 0 180 0.0 14.0 11 35 25 1 1.00 1.33 28.742414
38 Just Right Crunchy Nuggets K C 110 2 1 170 1.0 17.0 6 60 100 3 1.00 1.00 36.523683
39 Just Right Fruit & Nut K C 140 3 1 170 2.0 20.0 9 95 100 3 1.30 0.75 36.471512
40 Kix G C 110 2 1 260 0.0 21.0 3 40 25 2 1.00 1.50 39.241114
41 Life Q C 100 4 2 150 2.0 12.0 6 95 25 2 1.00 0.67 45.328074
42 Lucky Charms G C 110 2 1 180 0.0 12.0 12 55 25 2 1.00 1.00 26.734515
43 Maypo A H 100 4 1 0 0.0 16.0 3 95 25 2 1.00 1.00 54.850917
44 Muesli Raisins; Dates; & Almonds R C 150 4 3 95 3.0 16.0 11 170 25 3 1.00 1.00 37.136863
45 Muesli Raisins; Peaches; & Pecans R C 150 4 3 150 3.0 16.0 11 170 25 3 1.00 1.00 34.139765
46 Mueslix Crispy Blend K C 160 3 2 150 3.0 17.0 13 160 25 3 1.50 0.67 30.313351
47 Multi-Grain Cheerios G C 100 2 1 220 2.0 15.0 6 90 25 1 1.00 1.00 40.105965
48 Nut&Honey Crunch K C 120 2 1 190 0.0 15.0 9 40 25 2 1.00 0.67 29.924285
49 Nutri-Grain Almond-Raisin K C 140 3 2 220 3.0 21.0 7 130 25 3 1.33 0.67 40.692320
50 Nutri-grain Wheat K C 90 3 0 170 3.0 18.0 2 90 25 3 1.00 1.00 59.642837
51 Oatmeal Raisin Crisp G C 130 3 2 170 1.5 13.5 10 120 25 3 1.25 0.50 30.450843
52 Post Nat. Raisin Bran P C 120 3 1 200 6.0 11.0 14 260 25 3 1.33 0.67 37.840594
53 Product 19 K C 100 3 0 320 1.0 20.0 3 45 100 3 1.00 1.00 41.503540
54 Puffed Rice Q C 50 1 0 0 0.0 13.0 0 15 0 3 0.50 1.00 60.756112
55 Puffed Wheat Q C 50 2 0 0 1.0 10.0 0 50 0 3 0.50 1.00 63.005645
56 Quaker Oat Squares Q C 100 4 1 135 2.0 14.0 6 110 25 3 1.00 0.50 49.511874
57 Quaker Oatmeal Q H 100 5 2 0 2.7 0.0 0 110 0 1 1.00 0.67 50.828392
58 Raisin Bran K C 120 3 1 210 5.0 14.0 12 240 25 2 1.33 0.75 39.259197
59 Raisin Nut Bran G C 100 3 2 140 2.5 10.5 8 140 25 3 1.00 0.50 39.703400
60 Raisin Squares K C 90 2 0 0 2.0 15.0 6 110 25 3 1.00 0.50 55.333142
61 Rice Chex R C 110 1 0 240 0.0 23.0 2 30 25 1 1.00 1.13 41.998933
62 Rice Krispies K C 110 2 0 290 0.0 22.0 3 35 25 1 1.00 1.00 40.560159
63 Shredded Wheat N C 80 2 0 0 3.0 16.0 0 95 0 1 0.83 1.00 68.235885
64 Shredded Wheat 'n'Bran N C 90 3 0 0 4.0 19.0 0 140 0 1 1.00 0.67 74.472949
65 Shredded Wheat spoon size N C 90 3 0 0 3.0 20.0 0 120 0 1 1.00 0.67 72.801787
66 Smacks K C 110 2 1 70 1.0 9.0 15 40 25 2 1.00 0.75 31.230054
67 Special K K C 110 6 0 230 1.0 16.0 3 55 25 1 1.00 1.00 53.131324
68 Strawberry Fruit Wheats N C 90 2 0 15 3.0 15.0 5 90 25 2 1.00 1.00 59.363993
69 Total Corn Flakes G C 110 2 1 200 0.0 21.0 3 35 100 3 1.00 1.00 38.839746
70 Total Raisin Bran G C 140 3 1 190 4.0 15.0 14 230 100 3 1.50 1.00 28.592785
71 Total Whole Grain G C 100 3 1 200 3.0 16.0 3 110 100 3 1.00 1.00 46.658844
72 Triples G C 110 2 1 250 0.0 21.0 3 60 25 3 1.00 0.75 39.106174
73 Trix G C 110 1 1 140 0.0 13.0 12 25 25 2 1.00 1.00 27.753301
74 Wheat Chex R C 100 3 1 230 3.0 17.0 3 115 25 1 1.00 0.67 49.787445
75 Wheaties G C 100 3 1 200 3.0 17.0 3 110 25 1 1.00 1.00 51.592193
76 Wheaties Honey Gold G C 110 2 1 200 1.0 16.0 8 60 25 1 1.00 0.75 36.187559
In [2]:
Out[2]:
name mfr type calories protein fat sodium fiber carbo sugars potass vitamins shelf weight cups rating
count 77 77 77 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000 77.000000
unique 77 7 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
top 100% Bran K C NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
freq 1 23 74 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
mean NaN NaN NaN 106.883117 2.545455 1.012987 159.675325 2.151948 14.610390 6.935065 96.103896 28.246753 2.207792 1.029610 0.821039 42.665705
std NaN NaN NaN 19.484119 1.094790 1.006473 83.832295 2.383364 4.232257 4.422840 71.251147 22.342523 0.832524 0.150477 0.232716 14.047289
min NaN NaN NaN 50.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000 0.500000 0.250000 18.042851
25% NaN NaN NaN 100.000000 2.000000 0.000000 130.000000 1.000000 12.000000 3.000000 40.000000 25.000000 1.000000 1.000000 0.670000 33.174094
50% NaN NaN NaN 110.000000 3.000000 1.000000 180.000000 2.000000 14.000000 7.000000 90.000000 25.000000 2.000000 1.000000 0.750000 40.400208
75% NaN NaN NaN 110.000000 3.000000 2.000000 210.000000 3.000000 17.000000 11.000000 120.000000 25.000000 3.000000 1.000000 1.000000 50.828392
max NaN NaN NaN 160.000000 6.000000 5.000000 320.000000 14.000000 23.000000 15.000000 330.000000 100.000000 3.000000 1.500000 1.500000 93.704912
In [3]:
Out[3]:
<matplotlib.legend.Legend at 0x1b129c439d0>
In [4]:
6080100120140160100% BranAlmond DelightBran ChexCinnamon Toast CrunchCorn FlakesCream of Wheat (Quick)Froot LoopsFruitful BranGrape Nuts FlakesHoney Nut CheeriosKixMuesli Raisins; Dates; & AlmondsNut&Honey CrunchPost Nat. Raisin BranQuaker Oat SquaresRaisin SquaresShredded Wheat 'n'BranStrawberry Fruit WheatsTriplesWheaties Honey Gold
CEREALS AND THEIR CALORIE CONTENTCaloriesCereal Name
In [ ]:
In [5]:
N67.97A54.85K44.04Q42.92P41.71R41.54G34.49
NAKQPRGManufacturers Vs Ratings
In [6]:
C:\Users\ShubhaM Kharayat\anaconda3\lib\site-packages\plotly\express\_core.py:1637: FutureWarning:

The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

C:\Users\ShubhaM Kharayat\anaconda3\lib\site-packages\plotly\express\_core.py:1637: FutureWarning:

The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

C:\Users\ShubhaM Kharayat\anaconda3\lib\site-packages\plotly\express\_core.py:1637: FutureWarning:

The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

KGPQRNACCCCHCCHHAll-BranAll-Bran with Extra FiberApple JacksCorn FlakesCorn PopsCracklin' Oat BranCrispixFroot LoopsFrosted FlakesFrosted Mini-WheatsFruitful BranJust Right Crunchy NuggetsJust Right Fruit & NutMueslix Crispy BlendNut&Honey CrunchNutri-Grain Almond-RaisinNutri-grain WheatProduct 19Raisin BranRaisin SquaresRice KrispiesSmacksSpecial KApple Cinnamon CheeriosBasic 4CheeriosCinnamon Toast CrunchClustersCocoa PuffsCount ChoculaCrispy Wheat & RaisinsGolden GrahamsHoney Nut CheeriosKixLucky CharmsMulti-Grain CheeriosOatmeal Raisin CrispRaisin Nut BranTotal Corn FlakesTotal Raisin BranTotal Whole GrainTriplesTrixWheatiesWheaties Honey GoldBran FlakesFruit & Fibre Dates; Walnuts; and OatsFruity PebblesGolden CrispGrape Nuts FlakesGrape-NutsGreat Grains PecanHoney-combPost Nat. Raisin Bran100% Natural BranCap'n'CrunchHoney Graham OhsLifePuffed RicePuffed WheatQuaker Oat SquaresQuaker OatmealAlmond DelightBran ChexCorn ChexDouble ChexMuesli Raisins; Dates; & AlmondsMuesli Raisins; Peaches; & PecansRice ChexWheat Chex100% BranShredded WheatShredded Wheat 'n'BranShredded Wheat spoon sizeStrawberry Fruit WheatsCream of Wheat (Quick)Maypo
2030405060708090rating
In [7]:
60801001201401602030405060708090
Cereal100% Bran100% Natural BranAll-BranAll-Bran with Extra FiberAlmond DelightApple Cinnamon CheeriosApple JacksBasic 4Bran ChexBran FlakesCap'n'CrunchCheeriosCinnamon Toast CrunchClustersCocoa PuffsCorn ChexCorn FlakesCorn PopsCount ChoculaCracklin' Oat BranCream of Wheat (Quick)CrispixCrispy Wheat & RaisinsDouble ChexFroot LoopsFrosted FlakesFrosted Mini-WheatsFruit & Fibre Dates; Walnuts; and OatsFruitful BranFruity PebblesGolden CrispGolden GrahamsGrape Nuts FlakesGrape-NutsGreat Grains PecanHoney Graham OhsHoney Nut CheeriosHoney-combJust Right Crunchy NuggetsJust Right Fruit & NutKixLifeLucky CharmsMaypoMuesli Raisins; Dates; & AlmondsMuesli Raisins; Peaches; & PecansMueslix Crispy BlendMulti-Grain CheeriosNut&Honey CrunchNutri-Grain Almond-RaisinNutri-grain WheatOatmeal Raisin CrispPost Nat. Raisin BranProduct 19Puffed RicePuffed WheatQuaker Oat SquaresQuaker OatmealRaisin BranRaisin Nut BranRaisin SquaresRice ChexRice KrispiesShredded WheatShredded Wheat 'n'BranShredded Wheat spoon sizeSmacksSpecial KStrawberry Fruit WheatsTotal Corn FlakesTotal Raisin BranTotal Whole GrainTriplesTrixWheat ChexWheatiesWheaties Honey GoldCALORIE VS RATINGCaloriesrating
In [8]:
Out[8]:
(0.0, 98.06253244091141)
In [ ]:
In [ ]:
In [ ]: